Labels:crt screen | dialog box | hakham | laptop | monitor | sky | web site | window OCR: 640 SECTION c CHAPTER 11 Unlike sort order, an index has no bearing on the physical sequence of records on disk. An index simply points to the record where the data can be found The advantage of an index over sort is that table can have multi- ple indexes but only one sort order. For example, the Albums table could be indexed by Album Title to facilitate searches for specific albums. The same table could also be indexed by ArtistName to facilitate searches using artist names. Database tables should be indexed by any field or fields that are commonly used as search fields. The database designer typically creates indexes at the time the database structure is designed Indexes can also be created at later date as needed DESIGNING THE INTERFACE Does database designer have control over the user ...
